import pandas as pd

df = pd.read_csv("csvFile/dogNames2.csv")
# print(df)

#排序
df = df.sort_values(by="Count_AnimalName",ascending=False)
# print(df)

#pandas的方括号中写数组，表示取行，对行进行操作
#                写字符串，表示取列，对列进行操作
# print(df[:20])
# print(df["Row_Labels"])

#布尔索引
print(df[df["Count_AnimalName"]>100])

print(df[(df["Count_AnimalName"]>50) & (df["Count_AnimalName"]<100)])
